-- DBTools Manager Professional (Enterprise Edition)
-- Database Dump for: xpresso2_meta
-- Backup Generated in: 4/28/2007 3:12:22 PM
-- Database Server Version: MySQL 4.1.21

-- USEGO

SET FOREIGN_KEY_CHECKS=0;
-- GO


--
-- Dumping Tables
--

--
-- Table: app_formelements
--
CREATE TABLE `app_formelements` 
(
	`IdFormElement` bigint (20) NOT NULL AUTO_INCREMENT , 
	`IdForm` bigint (20), 
	`DisplayOrder` bigint (20) DEFAULT 0, 
	`DestinationTable` varchar (100), 
	`DestinationColumn` varchar (100), 
	`DestinationDataSourceId` integer (11) DEFAULT 0, 
	`ClassHandler` varchar (250), 
	`lookupDataSourceId` integer (11) DEFAULT 0, 
	`LookupQuery` text, 
	`Required` tinyint (1) DEFAULT 0, 
	`Label` text, 
	`Description` text, 
	`DataType` varchar (50), 
	`Style` varchar (100), 
	`Parameters` text, 
	`UniqueNameId` varchar (250),
	PRIMARY KEY (`IdFormElement`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: app_formelements
--
BEGIN;
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(968, 123, 30, 'usr_users', 'ZipCode', 6, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'ZipCode', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(967, 123, 27, 'usr_users', 'Country', 6, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Country', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(965, 123, 21, 'usr_users', 'City', 6, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'City', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(966, 123, 24, 'usr_users', 'State', 6, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'State', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(964, 123, 18, 'usr_users', 'Street', 6, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Street', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(962, 123, 12, 'usr_users', 'LastName', 6, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'LastName', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(963, 123, 15, 'usr_users', 'Telephone', 6, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Telephone', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(960, 123, 6, 'usr_users', 'Email', 6, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Email', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(961, 123, 9, 'usr_users', 'FirstName', 6, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'FirstName', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(959, 123, 3, 'usr_users', 'Password', 6, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Password', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(958, 123, 0, 'usr_users', 'UserName', 6, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'UserName', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(956, 122, 3, 'al_activity_log', 'na', 2, 'com.erclab.internal.xpresso.formelements.SimplePassword', 0, NULL, 1, 'Password:', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(957, 122, 1, 'al_activity_log', 'UserName', 2, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 1, 'User Name:', NULL, '', '', NULL, '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(933, 119, 1, 'na', 'objectName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, '', 0, 'Object Name', '', '', '', '', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(934, 119, 2, 'na', 'objectTarget', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, '', 0, 'Object Target (Table)', '', '', '', '', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(935, 119, 3, 'na', 'reportQuery', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, '', 0, 'Report Query', '', '', '', '', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(936, 119, 5, 'na', 'uniqueKeyName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, '', 0, 'Unique Key Name', '', '', '', '', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(937, 119, 6, 'na', 'idDataSourceRead', 1, 'com.erclab.internal.xpresso.formelements.DropDown', 1, 'SELECT idDataSource, dataSourceName FROM app_datasources', 0, 'Data Source Read', '', '', '', '', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(938, 119, 7, 'na', 'idDataSourceWrite', 1, 'com.erclab.internal.xpresso.formelements.DropDown', 1, 'SELECT idDataSource, dataSourceName FROM app_datasources', 0, 'Data Source Write', '', 'String', '', '', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(939, 119, 9, 'na', 'parentKeyName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 1, '', 0, 'Parent Key Name (Only for forms)', '', '', '', '', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(940, 119, 10, 'na', 'action', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 1, '', 0, 'Action (createForm or createReport)', '', 'String', '', '', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(941, 120, 0, 'app_forms', 'formName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'formName', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>0</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(942, 120, 3, 'app_forms', 'description', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'description', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>30</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(943, 120, 6, 'app_forms', 'title', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'title', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>60</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(944, 120, 9, 'app_forms', 'Image', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Image', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>90</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(945, 120, 12, 'app_forms', 'forwardUrl', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'forwardUrl', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>120</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(946, 120, 15, 'app_forms', 'uniqueKeyName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'uniqueKeyName', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>150</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(947, 120, 18, 'app_forms', 'style', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'style', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>180</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(948, 120, 21, 'app_forms', 'viewHandler', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'viewHandler', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>210</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(949, 120, 24, 'app_forms', 'loadScript', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'loadScript', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>240</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(950, 120, 27, 'app_forms', 'submitScript', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'submitScript', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>270</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(951, 120, 30, 'app_forms', 'elementChangeScript', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'elementChangeScript', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>300</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(952, 120, 33, 'app_forms', 'parentKeyName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'parentKeyName', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>330</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(953, 120, 36, 'app_forms', 'submitText', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'submitText', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>360</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(954, 120, 39, 'app_forms', 'formHelperClass', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'formHelperClass', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>390</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(955, 120, 42, 'app_forms', 'category', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'category', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>420</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(969, 124, 0, 'app_reports', 'reportName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Report Name', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>0</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(970, 124, 3, 'app_reports', 'query', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'query', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>30</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(971, 124, 6, 'app_reports', 'idDatasource', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'idDatasource', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>60</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(972, 124, 9, 'app_reports', 'isEditable', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'isEditable', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>90</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(973, 124, 12, 'app_reports', 'title', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'title', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>120</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(974, 124, 15, 'app_reports', 'description', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'description', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>150</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(975, 124, 18, 'app_reports', 'image', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'image', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>180</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(976, 124, 21, 'app_reports', 'uniqueKeyName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'uniqueKeyName', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>210</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(977, 124, 24, 'app_reports', 'category', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'category', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>240</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(978, 124, 27, 'app_reports', 'tableAssociated', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'tableAssociated', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>270</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(979, 124, 30, 'app_reports', 'recordsPerPage', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'recordsPerPage', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>300</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(980, 124, 33, 'app_reports', 'style', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'style', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>330</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(981, 124, 36, 'app_reports', 'viewHandler', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'viewHandler', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>360</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(982, 124, 39, 'app_reports', 'allowDelete', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'allowDelete', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>390</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(983, 124, 42, 'app_reports', 'reportHelperClass', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'reportHelperClass', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>420</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(984, 124, 45, 'app_reports', 'filterViewHandler', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'filterViewHandler', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>450</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(985, 124, 48, 'app_reports', 'exportViewHandler', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'exportViewHandler', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>480</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(986, 124, 51, 'app_reports', 'sortBy', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'sortBy', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>110</x><y>510</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(987, 124, 1, 'app_reports', 'idReport', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Id Report:', NULL, 'com.erclab.xpresso.formelements.TextInput', NULL, '<x>420</x><y>0</y>', NULL);
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(988, 120, 1, 'app_forms', 'idForm', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Id Form', NULL, 'com.erclab.xpresso.formelements.TextInput', NULL, '<x>430</x><y>0</y>', NULL);
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(989, 126, 0, 'gedas.employees', 'FirstName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'FirstName', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>0</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(990, 126, 3, 'gedas.employees', 'LatName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'LatName', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>30</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(991, 126, 6, 'gedas.employees', 'Department', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Department', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>60</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(992, 126, 9, 'gedas.employees', 'JobTitle', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'JobTitle', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>90</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(993, 126, 12, 'gedas.employees', 'Phone', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Phone', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>120</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(994, 126, 15, 'gedas.employees', 'Fax', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Fax', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>150</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(995, 126, 18, 'gedas.employees', 'Mailstop', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Mailstop', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>180</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(996, 126, 21, 'gedas.employees', 'Pager', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Pager', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>210</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(997, 126, 24, 'gedas.employees', 'Mobile', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Mobile', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>240</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(998, 126, 27, 'gedas.employees', 'Email', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Email', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>270</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(999, 126, 30, 'gedas.employees', 'Cube', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Cube', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>300</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1000, 126, 33, 'gedas.employees', 'ModifyDate', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'ModifyDate', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>330</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1001, 126, 36, 'gedas.employees', 'Other', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Other', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>360</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1002, 126, 39, 'gedas.employees', 'NetId', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'NetId', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>390</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1003, 126, 42, 'gedas.employees', 'picture', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'picture', NULL, 'com.erclab.xpresso.formelements.Image', '', '<x>420</x><y>40</y><width>120</width><height>120</height>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1004, 126, 1, 'gedas.employees', 'ID', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'ID', NULL, 'com.erclab.xpresso.formelements.Hidden', NULL, '<x>420</x><y>0</y>', NULL);
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1005, 127, 0, 'app_reports', 'reportName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'reportName', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>0</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1006, 127, 3, 'app_reports', 'query', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'query', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>30</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1007, 127, 6, 'app_reports', 'idDatasource', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'idDatasource', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>60</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1008, 127, 9, 'app_reports', 'isEditable', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'isEditable', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>90</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1009, 127, 12, 'app_reports', 'title', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'title', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>120</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1010, 127, 15, 'app_reports', 'description', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'description', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>150</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1011, 127, 18, 'app_reports', 'image', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'image', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>180</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1012, 127, 21, 'app_reports', 'uniqueKeyName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'uniqueKeyName', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>210</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1013, 127, 24, 'app_reports', 'category', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'category', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>240</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1014, 127, 27, 'app_reports', 'tableAssociated', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'tableAssociated', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>270</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1015, 127, 30, 'app_reports', 'recordsPerPage', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'recordsPerPage', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>300</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1016, 127, 33, 'app_reports', 'style', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'style', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>330</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1017, 127, 36, 'app_reports', 'viewHandler', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'viewHandler', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>360</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1018, 127, 39, 'app_reports', 'allowDelete', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'allowDelete', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>390</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1019, 127, 42, 'app_reports', 'reportHelperClass', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'reportHelperClass', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>420</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1020, 127, 45, 'app_reports', 'filterViewHandler', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'filterViewHandler', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>450</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1021, 127, 48, 'app_reports', 'exportViewHandler', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'exportViewHandler', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>480</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1022, 127, 51, 'app_reports', 'sortBy', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'sortBy', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>10</x><y>510</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1024, 128, 0, 'app_reportelements', 'IdReport', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'IdReport', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>0</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1025, 128, 3, 'app_reportelements', 'DisplayOrder', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'DisplayOrder', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>30</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1026, 128, 6, 'app_reportelements', 'ColumnName', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'ColumnName', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>60</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1027, 128, 9, 'app_reportelements', 'HeaderText', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'HeaderText', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>90</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1028, 128, 12, 'app_reportelements', 'ClassHandler', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'ClassHandler', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>120</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1029, 128, 15, 'app_reportelements', 'DisplayValue', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'DisplayValue', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>150</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1030, 128, 18, 'app_reportelements', 'Link', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'Link', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>180</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1031, 128, 21, 'app_reportelements', 'Style', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'Style', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>210</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1032, 128, 24, 'app_reportelements', 'ExternalDataQuery', 1, 'com.erclab.internal.xpresso.formelements.SimpleTextArea', 0, NULL, 0, 'ExternalDataQuery', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>240</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1033, 128, 27, 'app_reportelements', 'IdExternalDataSource', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'IdExternalDataSource', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>270</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1034, 128, 30, 'app_reportelements', 'IsTotalColumn', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'IsTotalColumn', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>300</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1035, 128, 33, 'app_reportelements', 'FilterDataType', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, 'FilterDataType', NULL, 'com.erclab.xpresso.formelements.TextInput', '', '<x>120</x><y>330</y>', '');
-- GO
INSERT INTO `app_formelements` (`IdFormElement`, `IdForm`, `DisplayOrder`, `DestinationTable`, `DestinationColumn`, `DestinationDataSourceId`, `ClassHandler`, `lookupDataSourceId`, `LookupQuery`, `Required`, `Label`, `Description`, `DataType`, `Style`, `Parameters`, `UniqueNameId`) VALUES(1036, 128, 1, 'app_reportelements', 'IdReportElement', 1, 'com.erclab.internal.xpresso.formelements.SimpleInputBox', 0, NULL, 0, '', NULL, 'com.erclab.xpresso.formelements.Hidden', NULL, NULL, NULL);
-- GO
COMMIT;
-- GO

--
-- Index: IdFormElementa
--
ALTER TABLE `xpresso2_meta`.`app_formelements` ADD INDEX IdFormElementa (IdFormElement );
-- GO

--
-- Table: app_forms
--
CREATE TABLE `app_forms` 
(
	`idForm` bigint (20) NOT NULL AUTO_INCREMENT , 
	`formName` varchar (100), 
	`description` text, 
	`title` text, 
	`Image` varchar (50), 
	`forwardUrl` varchar (250), 
	`uniqueKeyName` varchar (100) NOT NULL, 
	`style` varchar (100), 
	`viewHandler` varchar (100) NOT NULL, 
	`loadScript` text, 
	`submitScript` text, 
	`elementChangeScript` text, 
	`parentKeyName` varchar (100), 
	`submitText` varchar (100) DEFAULT 'Save', 
	`formHelperClass` varchar (100), 
	`category` varchar (250),
	PRIMARY KEY (`idForm`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: app_forms
--
BEGIN;
-- GO
INSERT INTO `app_forms` (`idForm`, `formName`, `description`, `title`, `Image`, `forwardUrl`, `uniqueKeyName`, `style`, `viewHandler`, `loadScript`, `submitScript`, `elementChangeScript`, `parentKeyName`, `submitText`, `formHelperClass`, `category`) VALUES(123, 'User', 'TBD D', 'User', '../html/images/defaultForm.gif', '-param:previousUrl-', 'IdUser', 'Generic', 'DynaForm.jsp', 'null', 'null', 'null', '', 'Save', 'com.erclab.internal.xpresso.security.RegistrationFormHelper', 'All');
-- GO
INSERT INTO `app_forms` (`idForm`, `formName`, `description`, `title`, `Image`, `forwardUrl`, `uniqueKeyName`, `style`, `viewHandler`, `loadScript`, `submitScript`, `elementChangeScript`, `parentKeyName`, `submitText`, `formHelperClass`, `category`) VALUES(122, 'Login', 'Description', 'Login', '../html/images/defaultForm.gif', '-param:previousUrl-', 'IdVisit', 'Generic', 'DynaForm.jsp', 'null', 'null', 'null', '', 'Save', 'com.erclab.internal.xpresso.security.LoginFormHelper', 'All');
-- GO
INSERT INTO `app_forms` (`idForm`, `formName`, `description`, `title`, `Image`, `forwardUrl`, `uniqueKeyName`, `style`, `viewHandler`, `loadScript`, `submitScript`, `elementChangeScript`, `parentKeyName`, `submitText`, `formHelperClass`, `category`) VALUES(119, 'ObjectCreator.config', 'Use this form to create Reports or Forms automatically', 'Object Creator', NULL, 'Index.jsp', 'na', NULL, 'ObjectCreator.jsp', NULL, NULL, NULL, NULL, 'Save', NULL, 'All');
-- GO
INSERT INTO `app_forms` (`idForm`, `formName`, `description`, `title`, `Image`, `forwardUrl`, `uniqueKeyName`, `style`, `viewHandler`, `loadScript`, `submitScript`, `elementChangeScript`, `parentKeyName`, `submitText`, `formHelperClass`, `category`) VALUES(120, 'Forms', 'The description', 'Forms', '../html/images/defaultForm.gif', '../jsp/flexResponse.jsp', 'idForm', 'Generic', 'DynaForm.jsp', NULL, NULL, NULL, '', 'Save', '', 'All');
-- GO
INSERT INTO `app_forms` (`idForm`, `formName`, `description`, `title`, `Image`, `forwardUrl`, `uniqueKeyName`, `style`, `viewHandler`, `loadScript`, `submitScript`, `elementChangeScript`, `parentKeyName`, `submitText`, `formHelperClass`, `category`) VALUES(124, 'Reports', 'TBD', 'Reports', '../html/images/defaultForm.gif', '../jsp/flexResponse.jsp', 'IdReport', 'Generic', '', NULL, NULL, NULL, '', 'Save', '', 'All');
-- GO
INSERT INTO `app_forms` (`idForm`, `formName`, `description`, `title`, `Image`, `forwardUrl`, `uniqueKeyName`, `style`, `viewHandler`, `loadScript`, `submitScript`, `elementChangeScript`, `parentKeyName`, `submitText`, `formHelperClass`, `category`) VALUES(126, 'Employees', 'Students description', 'Employees', '../html/images/defaultForm.gif', '../jsp/flexResponse.jsp', 'ID', 'Generic', 'DynaForm.jsp', 'null', 'null', 'null', '', 'Save', '', 'All');
-- GO
INSERT INTO `app_forms` (`idForm`, `formName`, `description`, `title`, `Image`, `forwardUrl`, `uniqueKeyName`, `style`, `viewHandler`, `loadScript`, `submitScript`, `elementChangeScript`, `parentKeyName`, `submitText`, `formHelperClass`, `category`) VALUES(128, 'ReportElements', 'TBD', 'ReportElements', '../html/images/defaultForm.gif', '../jsp/flexResponse.jsp', 'IdReportElement', 'Generic', 'DynaForm.jsp', NULL, NULL, NULL, '', 'Save', '', 'All');
-- GO
COMMIT;
-- GO

--
-- Table: app_options
--
CREATE TABLE `app_options` 
(
	`IdOption` bigint (20) NOT NULL AUTO_INCREMENT , 
	`IdReport` bigint (20) DEFAULT 0, 
	`IdForm` bigint (20) DEFAULT 0, 
	`OptionText` text, 
	`Style` varchar (100), 
	`Image` varchar (100), 
	`Link` text, 
	`DisplayOrder` integer (11),
	PRIMARY KEY (`IdOption`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: app_options
--
BEGIN;
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(1, 0, 0, 'DELETE-Milestones', '', '../html/images/layout/BulletUp.gif', 'Milestones.form?action=insert&uniqueKeyValue=-param:uniqueKeyValue-', 2);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(2, 22, 0, 'Deliverables', '', '../html/images/layout/BulletUp.gif', 'Deliverables.form?action=insert&uniqueKeyValue=-param:uniqueKeyValue-', 3);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(3, 22, 0, 'Risks', '', '../html/images/layout/BulletUp.gif', 'Risks.form?action=insert&uniqueKeyValue=-param:uniqueKeyValue-', 3);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(4, 0, 12, 'TLR Metrics', '', '../html/images/layout/BulletUp.gif', 'TLRMetrics.form?action=update&uniqueKeyValue=-param:uniqueKeyValue-', 1);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(5, 0, 0, 'DELETE-Milestones', '', '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Milestones&fromTLR=-param:uniqueKeyValue-&action=insert', 2);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(6, 0, 12, 'Deliverables', '', '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Deliverables&fromTLR=-param:uniqueKeyValue-&action=insert', 3);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(7, 0, 12, 'Risks', '', '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Risks&fromTLR=-param:uniqueKeyValue-&action=insert', 4);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(8, 0, 12, 'Issues', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Issues&fromTLR=-param:uniqueKeyValue-&action=insert', 5);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(9, 0, 12, 'PCRs', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=PCRs&fromTLR=-param:uniqueKeyValue-&action=insert', 6);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(77, 43, 0, 'Risk Log', NULL, '../html/images/layout/BulletUp.gif', 'RiskLog.filter', 2);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(10, 0, 12, 'View Internal TLR', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Internal.tlr&fromTLR=-param:uniqueKeyValue-\" target=\"_blank', 7);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(11, 0, 12, 'View Customer TLR', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Customer.tlr&fromTLR=-param:uniqueKeyValue-\" target=\"_blank', 8);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(12, 0, 12, 'View Americas TLR', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Americas.tlr&fromTLR=-param:uniqueKeyValue-\" target=\"_blank', 9);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(13, 0, 12, 'View VW SEP TLR', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=SEP.tlr&fromTLR=-param:uniqueKeyValue-\" target=\"_blank', 10);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(14, 0, 12, 'Submit TLR', 'SubmitTLROption', '../html/images/layout/BulletUp.gif', 'javascript:submitTLR(-param:uniqueKeyValue-)', 11);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(15, 21, 0, 'Your recent TLRs', 'Genric', '../html/images/layout/BulletUp.gif', 'UserTLRs.report', NULL);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(16, 0, 11, 'TLR Summary', '', '../html/images/layout/BulletUp.gif', 'EditTLR.form?action=update&uniqueKeyValue=-param:uniqueKeyValue-', 0);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(17, 0, 0, 'DELETE-Milestones', '', '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Milestones&fromTLR=-param:uniqueKeyValue-&action=insert', 2);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(18, 0, 11, 'Deliverables', '', '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Deliverables&fromTLR=-param:uniqueKeyValue-&action=insert', 3);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(19, 0, 11, 'Risks', '', '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Risks&fromTLR=-param:uniqueKeyValue-&action=insert', 4);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(20, 0, 11, 'Issues', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Issues&fromTLR=-param:uniqueKeyValue-&action=insert', 5);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(21, 0, 11, 'PCRs', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=PCRs&fromTLR=-param:uniqueKeyValue-&action=insert', 6);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(22, 0, 11, 'View Internal TLR', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Internal.tlr&fromTLR=-param:uniqueKeyValue-\" target=\"_blank', 7);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(23, 0, 11, 'View Customer TLR', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Customer.tlr&fromTLR=-param:uniqueKeyValue-\" target=\"_blank', 8);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(24, 0, 11, 'View Americas TLR', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=Americas.tlr&fromTLR=-param:uniqueKeyValue-\" target=\"_blank', 9);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(25, 0, 11, 'View VW SEP TLR', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=SEP.tlr&fromTLR=-param:uniqueKeyValue-\" target=\"_blank', 10);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(26, 0, 11, 'Submit TLR', 'SubmitTLROption', '../html/images/layout/BulletUp.gif', 'javascript:submitTLR(-param:uniqueKeyValue-)', 11);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(27, 21, 0, 'All available projects', '', '../html/images/layout/BulletUp.gif', 'AllProjects.report', NULL);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(68, 41, 0, 'Trend Report', NULL, '../html/images/layout/BulletUp.gif', 'Trend.filter', 1);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(69, 41, 0, 'Risk Log', NULL, '../html/images/layout/BulletUp.gif', 'RiskLog.filter', 2);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(70, 41, 0, 'Issue Log', NULL, '../html/images/layout/BulletUp.gif', 'IssueLog.filter', 3);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(71, 41, 0, 'Project Detail', NULL, '../html/images/layout/BulletUp.gif', 'ProjectDetail.filter', 4);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(86, 23, 0, 'Back to All Projects', NULL, '../html/images/layout/BulletUp.gif', 'AllProjects.report', 2);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(84, 40, 0, 'Search a Project', NULL, '../html/images/layout/BulletUp.gif', 'AllProjects.filter', NULL);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(85, 45, 0, 'Back to Admin', NULL, '../html/images/layout/BulletUp.gif', 'AdminLinks.report', NULL);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(72, 42, 0, 'Trend Report', NULL, '../html/images/layout/BulletUp.gif', 'Trend.filter', 1);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(73, 42, 0, 'Risk Log', NULL, '../html/images/layout/BulletUp.gif', 'RiskLog.filter', 2);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(74, 42, 0, 'Issue Log', NULL, '../html/images/layout/BulletUp.gif', 'IssueLog.filter', 3);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(40, 22, 0, 'Issues', NULL, '../html/images/layout/BulletUp.gif', 'Issues.form?action=insert&uniqueKeyValue=-param:uniqueKeyValue-', 1);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(41, 22, 0, 'PCRs', NULL, '../html/images/layout/BulletUp.gif', 'PCRs.form?action=insert&uniqueKeyValue=-param:uniqueKeyValue-', 4);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(42, 22, 0, 'TLRs', NULL, '../html/images/layout/BulletUp.gif', 'ProjectTLRs.report?uniqueKeyValue=-param:uniqueKeyValue-', 5);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(75, 42, 0, 'Project Detail', NULL, '../html/images/layout/BulletUp.gif', 'ProjectDetail.filter', 4);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(76, 43, 0, 'Trend Report', NULL, '../html/images/layout/BulletUp.gif', 'Trend.filter', 1);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(78, 43, 0, 'Issue Log', NULL, '../html/images/layout/BulletUp.gif', 'IssueLog.filter', 3);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(79, 43, 0, 'Project Detail', NULL, '../html/images/layout/BulletUp.gif', 'ProjectDetail.filter', 4);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(80, 37, 0, 'Trend Report', NULL, '../html/images/layout/BulletUp.gif', 'Trend.filter', 1);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(81, 37, 0, 'Risk Log', NULL, '../html/images/layout/BulletUp.gif', 'RiskLog.filter', 2);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(82, 37, 0, 'Issue Log', NULL, '../html/images/layout/BulletUp.gif', 'IssueLog.filter', 3);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(83, 37, 0, 'Project Detail', NULL, '../html/images/layout/BulletUp.gif', 'ProjectDetail.filter', 4);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(87, 23, 0, 'Back', NULL, '../html/images/layout/BulletUp.gif', 'javascript:history.go(-1);', 1);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(88, 0, 11, 'TLR Metrics', NULL, '../html/images/layout/BulletUp.gif', 'TLRMetrics.form?action=update&uniqueKeyValue=-param:uniqueKeyValue-', 1);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(89, 0, 12, 'TLR Summary', NULL, '../html/images/layout/BulletUp.gif', 'EditTLR.form?action=update&uniqueKeyValue=-param:uniqueKeyValue-', 0);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(90, 40, 0, 'All available projects', NULL, '../html/images/layout/BulletUp.gif', 'AllProjects.report', NULL);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(91, 22, 0, 'Back', NULL, '../html/images/layout/BulletUp.gif', 'javascript:history.go(-1)', 0);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(92, 23, 0, 'Issue Log', NULL, '../html/images/layout/BulletUp.gif', 'IssueLog.report?FilterSAP_NumberCondition=Equals&FilterSAP_Number=-param:uniqueKeyValue-', 3);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(93, 23, 0, 'Risk Log', NULL, '../html/images/layout/BulletUp.gif', 'RiskLog.report?FilterSAP_NumberCondition=Equals&FilterSAP_Number=-param:uniqueKeyValue-', 4);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(94, 23, 0, 'gFACT Reports', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=gFACTProjectReports&fromSAP=-param:uniqueKeyValue-\" target=\"_blank', 5);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(96, 22, 0, 'Issue Log', NULL, '../html/images/layout/BulletUp.gif', 'IssueLog.report?FilterSAP_NumberCondition=Equals&FilterSAP_Number=-param:uniqueKeyValue-', 10);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(95, 23, 0, 'Web Tracker Report', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=WebTracker&fromSAP=-param:uniqueKeyValue-\" target=\"_blank', 6);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(97, 22, 0, 'Risk Log', NULL, '../html/images/layout/BulletUp.gif', 'RiskLog.report?FilterSAP_NumberCondition=Equals&FilterSAP_Number=-param:uniqueKeyValue-', 12);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(98, 22, 0, 'gFACT Reports', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=gFACTProjectReports&fromSAP=-param:uniqueKeyValue-\" target=\"_blank', 14);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(99, 22, 0, 'Web Tracker Report', NULL, '../html/images/layout/BulletUp.gif', 'gprompt.navigate?target=WebTracker&fromSAP=-param:uniqueKeyValue-\" target=\"_blank', 15);
-- GO
INSERT INTO `app_options` (`IdOption`, `IdReport`, `IdForm`, `OptionText`, `Style`, `Image`, `Link`, `DisplayOrder`) VALUES(105, 23, 0, 'Project Info', NULL, '../html/images/layout/BulletUp.gif', 'ProjectInformation.report?uniqueKeyValue=-param:uniqueKeyValue-', 10);
-- GO
COMMIT;
-- GO

--
-- Index: IdReport
--
ALTER TABLE `xpresso2_meta`.`app_options` ADD INDEX IdReport (IdReport );
-- GO

--
-- Index: IdOption1
--
ALTER TABLE `xpresso2_meta`.`app_options` ADD INDEX IdOption1 (IdForm );
-- GO

--
-- Index: IdOption
--
ALTER TABLE `xpresso2_meta`.`app_options` ADD INDEX IdOption (IdOption );
-- GO

--
-- Table: app_reportelements
--
CREATE TABLE `app_reportelements` 
(
	`IdReportElement` bigint (20) NOT NULL AUTO_INCREMENT , 
	`IdReport` bigint (20) DEFAULT 0, 
	`DisplayOrder` bigint (20) DEFAULT 0, 
	`ColumnName` varchar (250), 
	`HeaderText` varchar (250), 
	`ClassHandler` varchar (250), 
	`DisplayValue` text, 
	`Link` text, 
	`Style` varchar (250), 
	`ExternalDataQuery` text, 
	`IdExternalDataSource` integer (11) DEFAULT 0, 
	`IsTotalColumn` tinyint (1) DEFAULT 0, 
	`FilterDataType` varchar (200),
	PRIMARY KEY (`IdReportElement`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: app_reportelements
--
BEGIN;
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(323, 51, 0, 'idReport', 'idReport', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(324, 51, 3, 'reportName', 'reportName', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(325, 51, 6, 'query', 'query', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(326, 51, 9, 'idDatasource', 'idDatasource', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(327, 51, 12, 'isEditable', 'Is Editable', 'com.erclab.internal.xpresso.reportelements.PrintValue', 'null', 'null', 'Generic', 'null', 0, 0, 'null');
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(328, 51, 15, 'title', 'title', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(329, 51, 18, 'description', 'description', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(330, 51, 21, 'image', 'image', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(331, 51, 24, 'uniqueKeyName', 'uniqueKeyName', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(332, 51, 27, 'category', 'category', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(333, 51, 30, 'tableAssociated', 'tableAssociated', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(334, 51, 33, 'recordsPerPage', 'recordsPerPage', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(335, 51, 36, 'style', 'style', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(336, 51, 39, 'viewHandler', 'viewHandler', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(337, 51, 42, 'allowDelete', 'allowDelete', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(338, 51, 45, 'reportHelperClass', 'reportHelperClass', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(339, 51, 48, 'filterViewHandler', 'filterViewHandler', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(340, 51, 51, 'exportViewHandler', 'exportViewHandler', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(341, 51, 54, 'sortBy', 'sortBy', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(358, 54, 0, 'idForm', 'idForm', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(359, 54, 3, 'formName', 'formName', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(360, 54, 6, 'description', 'description', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(361, 54, 9, 'title', 'title', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(362, 54, 12, 'Image', 'Image', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(363, 54, 15, 'forwardUrl', 'forwardUrl', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(364, 54, 18, 'uniqueKeyName', 'uniqueKeyName', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(365, 54, 21, 'style', 'style', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(366, 54, 24, 'viewHandler', 'viewHandler', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(367, 54, 27, 'loadScript', 'loadScript', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(368, 54, 30, 'submitScript', 'submitScript', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(369, 54, 33, 'elementChangeScript', 'elementChangeScript', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(370, 54, 36, 'parentKeyName', 'parentKeyName', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(371, 54, 39, 'submitText', 'submitText', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(372, 54, 42, 'formHelperClass', 'formHelperClass', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(373, 54, 45, 'category', 'category', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(374, 55, 1, 'ClaimID', 'ClaimID', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, NULL, NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(375, 55, 2, 'VIN', 'VIN', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, NULL, NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(376, 55, 3, 'Comment', 'Comment', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, NULL, NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(377, 55, 4, 'UserID', 'UserID', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, NULL, NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(378, 55, 0, 'UPSNumber', 'UPSNumber', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, NULL, NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(379, 55, 4, 'Model', 'Model', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, NULL, NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(380, 55, 0, 'TotalLabor', 'TotalLabor', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, NULL, NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(381, 56, 0, 'RegionDescription', 'RegionDescription', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, NULL, NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(382, 56, 2, 'counter', 'counter', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, NULL, NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(383, 58, 0, 'ID', 'ID', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(384, 58, 3, 'FirstName', 'FirstName', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(385, 58, 6, 'LatName', 'Last Name', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(386, 58, 9, 'Department', 'Department', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(387, 58, 12, 'JobTitle', 'JobTitle', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(388, 58, 15, 'Phone', 'Phone', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(389, 58, 18, 'Fax', 'Fax', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(390, 58, 21, 'Mailstop', 'Mailstop', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(391, 58, 24, 'Pager', 'Pager', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(392, 58, 27, 'Mobile', 'Mobile', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(393, 58, 30, 'Email', 'Email', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(394, 58, 33, 'Cube', 'Cube', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(395, 58, 36, 'ModifyDate', 'ModifyDate', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(396, 58, 39, 'Other', 'Other', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(397, 58, 42, 'NetId', 'NetId', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(398, 58, 45, 'picture', 'picture', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(399, 59, 0, 'label', 'label', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(400, 59, 3, 'data', 'data', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(401, 59, 6, 'idReport', 'idReport', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(402, 59, 9, 'reportName', 'reportName', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(403, 59, 12, 'query', 'query', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(404, 59, 15, 'idDatasource', 'idDatasource', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(405, 59, 18, 'isEditable', 'isEditable', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(406, 59, 21, 'title', 'title', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(407, 59, 24, 'description', 'description', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(408, 59, 27, 'image', 'image', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(409, 59, 30, 'uniqueKeyName', 'uniqueKeyName', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(410, 59, 33, 'category', 'category', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(411, 59, 36, 'tableAssociated', 'tableAssociated', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(412, 59, 39, 'recordsPerPage', 'recordsPerPage', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(413, 59, 42, 'style', 'style', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(414, 59, 45, 'viewHandler', 'viewHandler', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(415, 59, 48, 'allowDelete', 'allowDelete', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(416, 59, 51, 'reportHelperClass', 'reportHelperClass', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(417, 59, 54, 'filterViewHandler', 'filterViewHandler', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(418, 59, 57, 'exportViewHandler', 'exportViewHandler', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(419, 59, 60, 'sortBy', 'sortBy', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(433, 62, 0, 'IdReportElement', 'IdReportElement', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(434, 62, 3, 'IdReport', 'IdReport', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(435, 62, 6, 'DisplayOrder', 'DisplayOrder', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(436, 62, 9, 'ColumnName', 'ColumnName', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(437, 62, 12, 'HeaderText', 'HeaderText', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(438, 62, 15, 'ClassHandler', 'ClassHandler', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(439, 62, 18, 'DisplayValue', 'DisplayValue', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(440, 62, 21, 'Link', 'Link', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(441, 62, 24, 'Style', 'Style', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(442, 62, 27, 'ExternalDataQuery', 'ExternalDataQuery', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(443, 62, 30, 'IdExternalDataSource', 'IdExternalDataSource', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(444, 62, 33, 'IsTotalColumn', 'IsTotalColumn', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
INSERT INTO `app_reportelements` (`IdReportElement`, `IdReport`, `DisplayOrder`, `ColumnName`, `HeaderText`, `ClassHandler`, `DisplayValue`, `Link`, `Style`, `ExternalDataQuery`, `IdExternalDataSource`, `IsTotalColumn`, `FilterDataType`) VALUES(445, 62, 36, 'FilterDataType', 'FilterDataType', 'com.erclab.internal.xpresso.reportelements.PrintValue', NULL, NULL, 'Generic', NULL, 0, 0, NULL);
-- GO
COMMIT;
-- GO

--
-- Index: IdReportElement
--
ALTER TABLE `xpresso2_meta`.`app_reportelements` ADD INDEX IdReportElement (IdReportElement );
-- GO

--
-- Index: IdReport
--
ALTER TABLE `xpresso2_meta`.`app_reportelements` ADD INDEX IdReport (IdReport );
-- GO

--
-- Table: app_reportfilters
--
CREATE TABLE `app_reportfilters` 
(
	`IdFilter` integer (11) NOT NULL AUTO_INCREMENT , 
	`IdReport` integer (11) NOT NULL DEFAULT 0, 
	`ClassHandler` varchar (200) NOT NULL, 
	`ColumnToFilter` varchar (100), 
	`LookupDataSourceId` integer (11) DEFAULT 0, 
	`LookupQuery` text, 
	`Label` varchar (250), 
	`Style` varchar (100), 
	`DisplayOrder` integer (11) DEFAULT 0, 
	`FlexClass` varchar (100), 
	`Parameters` text,
	PRIMARY KEY (`IdFilter`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: app_reportfilters
--
BEGIN;
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(1, 37, 'com.gedas.internal.gprompt.reportfilters.StartEndDateTrend', 'Report_Date', 0, NULL, 'Start Date:', 'Generic', 0, '', '&nbsp;<span class=\"GenericFilterLabel\">End Date:</span>');
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(3, 41, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'ProjectTitle', 0, NULL, 'Project Name:', 'Generic', 2, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(4, 41, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'his.ProjectManager', 0, NULL, 'Project Manager:', 'Generic', 3, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(5, 41, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'lobName', 0, NULL, 'BU:', 'Generic', 4, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(23, 41, 'com.gedas.internal.gprompt.reportfilters.ProjectDetailDateFilter', 'Report_Start_Date', 0, NULL, 'Snapshot Date:', 'Generic', 0, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(7, 0, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'SAP_Number', 0, NULL, 'SAP Number:', 'Generic', 0, '', 'DELETE ?? - IdReport=42');
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(8, 0, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'SAP_Number', 0, NULL, 'SAP Number:', 'Generic', 0, '', 'DELETE ?? - IdProject=43');
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(9, 0, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'SAP_Number', 0, NULL, 'SAP Number', 'Generic', 0, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(10, 37, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'His.SAP_Number', 0, NULL, 'SAP Number:', 'Generic', 0, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(13, 37, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'His.ProjectManager', 0, NULL, 'Project Manager:', 'Generic', 0, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(12, 37, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'ProjectTitle', 0, NULL, 'Project Name:', 'Generic', 0, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(14, 37, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'lobName', 0, NULL, 'Business Unit:', 'Generic', 0, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(15, 37, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'cc.CostCenterNumber', 0, NULL, 'Cost Center:', 'Generic', 0, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(16, 37, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'BURep', 0, NULL, 'BU Rep:', 'Generic', 0, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(17, 41, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'His.SAP_Number', 0, NULL, 'SAP Number', 'Generic', 1, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(18, 41, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'gf.CostCenterNumber', 0, NULL, 'Cost Center:', 'Generic', 5, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(19, 41, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'his.Delivery_Manager', 0, NULL, 'Delivery Manager:', 'Generic', 6, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(20, 45, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'SAP_Number', 0, NULL, 'SAP Number:', 'Generic', 0, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(21, 40, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'T1.SAP_Number', 0, NULL, 'SAP Number:', 'Generic', 0, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(22, 40, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'ProjectTitle', 0, NULL, 'Project Name:', 'Generic', 0, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(25, 42, 'com.gedas.internal.gprompt.reportfilters.RiskIssueLogProjectFilter', 'SAP_Number', 0, NULL, 'Project Name:', 'Generic', 1, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(26, 43, 'com.gedas.internal.gprompt.reportfilters.RiskIssueLogProjectFilter', 'SAP_Number', 0, NULL, 'Project Name:', 'Generic', 1, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(27, 43, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'Issue_Status', 0, NULL, 'Issue Status:', 'Generic', 2, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(28, 43, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'Responsible_Party_Name', 0, NULL, 'Responsible:', 'Generic', 3, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(29, 43, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'Priority_Code', 0, NULL, 'Priority:', 'Generic', 4, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(30, 42, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'Responsible_Party_Name', 0, NULL, 'Responsible:', 'Generic', 2, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(31, 42, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'Priority_Code', 0, NULL, 'Priority:', 'Generic', 3, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(32, 42, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'Risk_Description', 0, NULL, 'Description', 'Generic', 4, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(33, 43, 'com.gedas.internal.grad.reports.filters.MysqlSimpleColumnFilter', 'Issue_Description', 0, NULL, 'Description', 'Generic', 5, '', NULL);
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(34, 58, 'com.erclab.internal.xpresso.reports.filters.MysqlSimpleColumnFilter', 'FirstName', 0, NULL, 'First Name', 'Generic', 3, 'com.erclab.xpresso.reports.filters.SimpleTextFilter', '<x>120</x><y>40</y>');
-- GO
INSERT INTO `app_reportfilters` (`IdFilter`, `IdReport`, `ClassHandler`, `ColumnToFilter`, `LookupDataSourceId`, `LookupQuery`, `Label`, `Style`, `DisplayOrder`, `FlexClass`, `Parameters`) VALUES(35, 58, 'com.erclab.internal.xpresso.reports.filters.MysqlSimpleColumnFilter', 'LastName', 0, NULL, 'Last Name', NULL, 1, 'com.erclab.xpresso.reports.filters.SimpleTextFilter', '<x>120</x><y>10</y>');
-- GO
COMMIT;
-- GO

--
-- Table: app_reports
--
CREATE TABLE `app_reports` 
(
	`idReport` bigint (20) NOT NULL AUTO_INCREMENT , 
	`reportName` varchar (255) NOT NULL, 
	`query` mediumtext, 
	`idDatasource` integer (11) NOT NULL DEFAULT 0, 
	`isEditable` integer (1), 
	`title` varchar (250), 
	`description` text, 
	`image` varchar (250), 
	`uniqueKeyName` varchar (250), 
	`category` varchar (250), 
	`tableAssociated` varchar (250), 
	`recordsPerPage` integer (11) NOT NULL DEFAULT 20, 
	`style` varchar (100), 
	`viewHandler` varchar (100) NOT NULL, 
	`allowDelete` integer (1) DEFAULT 0, 
	`reportHelperClass` varchar (100), 
	`filterViewHandler` varchar (200), 
	`exportViewHandler` varchar (100) DEFAULT 'DynaReportExport.jsp', 
	`sortBy` varchar (150),
	PRIMARY KEY (`idReport`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: app_reports
--
BEGIN;
-- GO
INSERT INTO `app_reports` (`idReport`, `reportName`, `query`, `idDatasource`, `isEditable`, `title`, `description`, `image`, `uniqueKeyName`, `category`, `tableAssociated`, `recordsPerPage`, `style`, `viewHandler`, `allowDelete`, `reportHelperClass`, `filterViewHandler`, `exportViewHandler`, `sortBy`) VALUES(54, 'Forms', 'SELECT * FROM app_forms', 1, 0, 'Forms', 'Description - Forms - New word', '../html/images/defaultReport.gif', 'idForm', 'All', 'app_forms', 20, 'Generic', 'DynaReport.jsp', 0, '', '', 'DynaReportExport.jsp', 'idForm');
-- GO
INSERT INTO `app_reports` (`idReport`, `reportName`, `query`, `idDatasource`, `isEditable`, `title`, `description`, `image`, `uniqueKeyName`, `category`, `tableAssociated`, `recordsPerPage`, `style`, `viewHandler`, `allowDelete`, `reportHelperClass`, `filterViewHandler`, `exportViewHandler`, `sortBy`) VALUES(51, 'Reports', 'SELECT * FROM app_reports', 1, NULL, 'Reports.title', 'Reports.Description', '../html/images/defaultReport.gif', 'idReport', 'All', 'app_reports', 20, 'Generic', 'DynaReport.jsp', 1, '', '', 'DynaReportExport.jsp', 'idReport');
-- GO
INSERT INTO `app_reports` (`idReport`, `reportName`, `query`, `idDatasource`, `isEditable`, `title`, `description`, `image`, `uniqueKeyName`, `category`, `tableAssociated`, `recordsPerPage`, `style`, `viewHandler`, `allowDelete`, `reportHelperClass`, `filterViewHandler`, `exportViewHandler`, `sortBy`) VALUES(55, 'SimpleClaims', 'SELECT *\rFROM `tbl_claim` where RegionID=14 and dealerID=1812', 4, 0, 'Simple Claims Report From XML', 'test', 'null', 'ClaimID', 'All', 'tbl_claim', 120, 'null', 'DynaReport.jsp', 0, '', 'null', 'DynaReportExport.jsp', 'claimID');
-- GO
INSERT INTO `app_reports` (`idReport`, `reportName`, `query`, `idDatasource`, `isEditable`, `title`, `description`, `image`, `uniqueKeyName`, `category`, `tableAssociated`, `recordsPerPage`, `style`, `viewHandler`, `allowDelete`, `reportHelperClass`, `filterViewHandler`, `exportViewHandler`, `sortBy`) VALUES(56, 'ClaimsByRegion', 'SELECT CONCAT(\"Region \", RegionId) as RegionDescription, count(*) as counter, RegionID\rFROM tbl_claim where RegionID is not null group by RegionID ', 4, 0, 'Claims Per Region 4', 'null', 'null', 'RegionID', 'All', 'tbl_claim', 0, 'null', '', 0, 'null', 'null', 'DynaReportExport.jsp', 'RegionID');
-- GO
INSERT INTO `app_reports` (`idReport`, `reportName`, `query`, `idDatasource`, `isEditable`, `title`, `description`, `image`, `uniqueKeyName`, `category`, `tableAssociated`, `recordsPerPage`, `style`, `viewHandler`, `allowDelete`, `reportHelperClass`, `filterViewHandler`, `exportViewHandler`, `sortBy`) VALUES(58, 'Employees', 'SELECT * FROM gedas.employees', 2, 0, 'Employees', 'Description - Employees', '../html/images/defaultReport.gif', 'ID', 'All', 'gedas.employees', 20, 'Generic', 'DynaReport.jsp', 0, '', '', 'DynaReportExport.jsp', 'ID');
-- GO
INSERT INTO `app_reports` (`idReport`, `reportName`, `query`, `idDatasource`, `isEditable`, `title`, `description`, `image`, `uniqueKeyName`, `category`, `tableAssociated`, `recordsPerPage`, `style`, `viewHandler`, `allowDelete`, `reportHelperClass`, `filterViewHandler`, `exportViewHandler`, `sortBy`) VALUES(59, 'Objects', 'SELECT ReportName as label, ReportName as data, app_reports.* FROM app_reports', 1, NULL, 'Objects', 'Description - Objects', '../html/images/defaultReport.gif', 'IdReport', 'All', 'app_reports', 20, 'Generic', 'DynaReport.jsp', 0, '', '', 'DynaReportExport.jsp', 'IdReport');
-- GO
INSERT INTO `app_reports` (`idReport`, `reportName`, `query`, `idDatasource`, `isEditable`, `title`, `description`, `image`, `uniqueKeyName`, `category`, `tableAssociated`, `recordsPerPage`, `style`, `viewHandler`, `allowDelete`, `reportHelperClass`, `filterViewHandler`, `exportViewHandler`, `sortBy`) VALUES(62, 'ReportElements', 'SELECT * FROM app_reportElements', 1, NULL, 'ReportElements', 'Description - ReportElements', '../html/images/defaultReport.gif', 'IdReportElement', 'All', 'app_reportelements', 20, 'Generic', 'DynaReport.jsp', 0, '', '', 'DynaReportExport.jsp', 'IdReportElement');
-- GO
COMMIT;
-- GO

--
-- Index: IdentifierColumn
--
ALTER TABLE `xpresso2_meta`.`app_reports` ADD INDEX IdentifierColumn (uniqueKeyName );
-- GO

--
-- Table: app_visitlog
--
CREATE TABLE `app_visitlog` 
(
	`IdVisit` integer (11) NOT NULL AUTO_INCREMENT , 
	`netid` varchar (100) NOT NULL, 
	`VisitDate` timestamp NOT NULL, 
	`UserName` varchar (100) NOT NULL,
	PRIMARY KEY (`IdVisit`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: app_visitlog
--
BEGIN;
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(1, 'guest', '2006-02-18 11:44:22', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(2, 'guest', '2006-02-18 11:47:24', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(3, 'guest', '2006-02-18 12:38:25', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(4, 'guest', '2006-02-19 16:24:55', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(5, 'guest', '2006-02-25 14:53:01', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(6, 'guest', '2006-02-25 15:28:21', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(7, 'guest', '2006-02-25 16:05:10', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(8, 'guest', '2006-02-25 16:55:19', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(9, 'guest', '2006-02-25 16:57:55', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(10, 'guest', '2006-02-25 16:58:07', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(11, 'guest', '2006-02-25 17:28:31', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(12, 'guest', '2006-02-25 17:33:14', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(13, 'guest', '2006-02-25 17:42:06', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(14, 'guest', '2006-02-25 18:23:11', 'Guest');
-- GO
INSERT INTO `app_visitlog` (`IdVisit`, `netid`, `VisitDate`, `UserName`) VALUES(15, 'guest', '2006-02-25 18:25:23', 'Guest');
-- GO
COMMIT;
-- GO

--
-- Table: dts_datasources
--
CREATE TABLE `dts_datasources` 
(
	`idDataSource` integer (11) NOT NULL AUTO_INCREMENT , 
	`dataSourceName` varchar (200) NOT NULL, 
	`classHandler` varchar (100) NOT NULL, 
	`parameters` text NOT NULL,
	PRIMARY KEY (`idDataSource`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: dts_datasources
--
BEGIN;
-- GO
INSERT INTO `dts_datasources` (`idDataSource`, `dataSourceName`, `classHandler`, `parameters`) VALUES(1, 'xpresso Meta', 'com.erclab.internal.xpresso.dataAccess.MysqlDatasource', 'username=root\npassword=admin\ndriverClassName=com.mysql.jdbc.Driver\nurl=jdbc:mysql://localhost/xpresso_meta\nmaxIdle=8\nmaxWait=20');
-- GO
INSERT INTO `dts_datasources` (`idDataSource`, `dataSourceName`, `classHandler`, `parameters`) VALUES(6, 'iNet Users', 'com.erclab.internal.xpresso.dataAccess.MysqlDatasource', 'username=root\npassword=admin\ndriverClassName=com.mysql.jdbc.Driver\nurl=jdbc:mysql://localhost/inet_users\nmaxIdle=8\nmaxWait=20');
-- GO
INSERT INTO `dts_datasources` (`idDataSource`, `dataSourceName`, `classHandler`, `parameters`) VALUES(2, 'xpresso Data', 'com.erclab.internal.xpresso.dataAccess.MysqlDatasource', 'username=root\npassword=admin\ndriverClassName=com.mysql.jdbc.Driver\nurl=jdbc:mysql://localhost/xpresso_data\nmaxIdle=8\nmaxWait=20');
-- GO
INSERT INTO `dts_datasources` (`idDataSource`, `dataSourceName`, `classHandler`, `parameters`) VALUES(4, 'WTC Data', 'com.erclab.internal.xpresso.dataAccess.MysqlDatasource', 'username=admin\npassword=admin\ndriverClassName=com.mysql.jdbc.Driver\nurl=jdbc:mysql://usgedahb03av/wtc\nmaxIdle=8\nmaxWait=20');
-- GO
COMMIT;
-- GO

--
-- Dumping Tables Foreign Keys
--
SET FOREIGN_KEY_CHECKS=1;
-- GO

